﻿CREATE TABLE [dbo].[ASMS_Supplier]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[BusinessId] uniqueidentifier,
	[StationId] uniqueidentifier,
	[Code] nvarchar(32) NOT NULL,
	[Name] nvarchar(32) NOT NULL,
	[Pinyin] nvarchar(64),
	[Letter] nvarchar(16),
	[ContactName] nvarchar( 32),
	[ContactTelephone] nvarchar(32),
	[Telephone] nvarchar(32),
	[Country] nvarchar(32),
	[Province] nvarchar(32),
	[City] nvarchar(32),
	[District] nvarchar(32),
	[Address] nvarchar(256),
	[TaxNumber] nvarchar(64),
	[BankAccount] nvarchar(128),
	[QQ] nvarchar(32),
	[Fax] nvarchar(32),
	[Email] nvarchar(128),
	[Description] nvarchar(256),
	[Status] int NOT NULL,
	[CreatedTime] datetime NOT NULL,
	[Creator] nvarchar(64) NOT NULL
)
